package com.qijian.maindata.domain.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import com.alibaba.excel.enums.poi.BorderStyleEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import lombok.Data;

import java.util.Date;

@Data
@ColumnWidth(12)
@HeadRowHeight(value = 15)
@HeadStyle(
        fillForegroundColor = 55,
        horizontalAlignment = HorizontalAlignmentEnum.CENTER,
        borderBottom = BorderStyleEnum.THIN,
        borderLeft = BorderStyleEnum.THIN,borderRight = BorderStyleEnum.THIN,borderTop = BorderStyleEnum.THIN)//表头样式
@ContentStyle(borderBottom = BorderStyleEnum.THIN,borderLeft = BorderStyleEnum.THIN,borderRight = BorderStyleEnum.THIN,borderTop = BorderStyleEnum.THIN)
public class ProjectExcelVo {


    @ExcelProperty(value = "开工令", order = 1)
    private String projectNo;

    @ExcelProperty(value = "项目名称",order = 2)
    @ColumnWidth(value = 45)
    private String projectName;

    @ExcelProperty(value = "机台号", order = 3)
    private String machineNo;

    @ExcelProperty(value = "客户名称",order = 4)
    private String customerName;

    @ExcelProperty(value = "项目经理",order = 5)
    private String nickName;

    @ExcelProperty(value = "项目经理联系方式", order = 6)
    @ColumnWidth(value = 30)
    private String phoneNumber;

    @ExcelProperty(value = "物料编号", order = 7)
    private String itemCode;


    @ExcelProperty(value = "产品重量(Kg)", order = 8)
    private String itemWeight;

    @ExcelProperty(value = "BOM名称", order = 9)
    private String bomName;

    @ExcelProperty(value = "项目状态", order = 10)
    private String statusLabel;

    /**
     * 完成时间
     */
    @DateTimeFormat(value = "yyyy-MM-dd")
    @ExcelProperty(value = "完成时间",order = 11)
    private Date completeTime;

    @DateTimeFormat(value = "yyyy-MM-dd")
    @ExcelProperty(value = "商务交期",order = 12)
    private Date expireTime;

}
